Course objectives:
|
The subject gives basics of theoretical and practical knowledge of data processing in environment of spreadsheet. It is focused on use of standard functions, dynamic formulas, graphs, analytic methods and others.
|
Requirements on student
|
Mid-term written examination - 60% of eventuality points.
|
Content
|
Characteristics of spreadsheets.
Adding data to a spreadsheet.
Cell adressing.
Adding the Date and a Range Name.
Adding formulas. Applying styles.
Changing data alignment in cells. Number formatting - percent and currency
Changing font color. Graphs.
Filter, database functions.
Agregate.
Pivot table.
Cooperation with other applications.
|
Activities
|
|
Fields of study
|
|
Guarantors and lecturers
|
|
Literature
|
|
Time requirements
|
All forms of study
|
Activities
|
Time requirements for activity [h]
|
Preparation for comprehensive test (10-40)
|
26
|
Practical training (number of hours)
|
26
|
Total
|
52
|
|
Prerequisites
|
Knowledge - students are expected to possess the following knowledge before the course commences to finish it successfully: |
Basic knowledge of using a computer. |
knowledge of extracting information from electronic sources |
basic knowledge of the user interface of MS Windows |
Skills - students are expected to possess the following skills before the course commences to finish it successfully: |
basic skill work with computer |
use basic safety rules with electronic resources (username, password) |
backup files |
Competences - students are expected to possess the following competences before the course commences to finish it successfully: |
N/A |
|
Learning outcomes
|
Knowledge - knowledge resulting from the course: |
knowledge fundametals of data processing |
knowledge basic structure of data types |
Skills - skills resulting from the course: |
the ability to implement data structures in a spreadsheet environment |
the ability to create presentations |
the ability of more complex data processing |
Competences - competences resulting from the course: |
N/A |
|
Assessment methods
|
Knowledge - knowledge achieved by taking this course are verified by the following means: |
Test |
Skills demonstration during practicum |
Skills - skills achieved by taking this course are verified by the following means: |
Continuous assessment |
|
Teaching methods
|
Knowledge - the following training methods are used to achieve the required knowledge: |
Practicum |
|